Lessons Learned¶

/opt/conda/lib/python3.9/site-packages/geopandas/_compat.py:111: UserWarning: The Shapely GEOS version (3.10.2-CAPI-1.16.0) is incompatible with the GEOS version PyGEOS was compiled with (3.10.1-CAPI-1.16.0). Conversions between both will be slow.
  warnings.warn(

Basics¶

'346 total applications'
'121 different organizations applied.'
How many applications were submitted through the consolidated application?
Yes    343
No       3
Name: consolidated_application, dtype: int64
How many applications were submitted vs. not submitted?
Submitted        338
Not Submitted      8
Name: application_status, dtype: int64
The following organizations did not submit their one of applications.
['City of Tracy',
 'County of Siskiyou',
 'Metropolitan Transportation Commission',
 'Redding Area Bus Aurthority',
 'San Francisco Municipal Transportation Agency',
 'Tuolumne County Transit Agency',
 'Western Contra Costa Transit Authority']

Total Funds Requested - $624 Million¶

  • Only includes 'state total' and 'federal total.'
/tmp/ipykernel_7186/3732048006.py:2: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
total_state_fed_only
346 $624.0M

How was the funding split?¶

  • Bulk of the funding comes from state grants.

/tmp/ipykernel_7186/415235289.py:1: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

What are the most popular funds, looking at amount requested?¶

  • The most popular grant is LCTOP, "Other" state funds, and Transit Development Act.

/tmp/ipykernel_7186/943889312.py:2: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

Are projects fully funded?¶

Methodology

  • Totaled up "local total", "federal total", "other federal funds", and "state funds".
  • Compared the total above with "total expenses" column.
  • Categorized the comparison into fully funded, funding exceeds total expense, and not fully funded.

What do organizations want to do with the grant funding?¶

  • Most applications are for projects related to Operating Assistance.

What are the most popular combinations of programs an organization applies for?¶

  • There are only 335 rows in this data set. There are 346 rows in the original dataframe.
    • This is due to the fact that I had to pivot the data different and filtered out any rows with $0 below across all monetary fields and rows with values populated only in the state total or federal total columns.
  • Looking at the top ten most popular combination of programs
    • Majority of applications only applied for LCTOP, followed by 5311, and 5311 in combination with Transit Development Act.
  all_programs values percentage_of_total_applications
0 LCTOP (State) 99 30%
1 5311 (Fed) 72 21%
2 5311 (Fed),Transit Development Act (State) 39 12%
3 5339 (Fed) 29 9%
4 5311(f) (Fed) 15 4%
5 5311 (Fed),Other State Funds 14 4%
6 5339 (Fed),Other State Funds 11 3%
7 5311(f) (Fed),Transit Development Act (State) 9 3%
8 5311 CMAQ (Fed) 6 2%
9 5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State) 5 1%

Analyzing applications that include LCTOP and at least one other grant:¶

  • 23 total applications.
  • 12 different combinations of applications including LCTOP and 1+ program.
  • LCTOP and Other State Funds is the most popular combination, followed by 5311 and LCTOP.
  program combinations count of applications in this combination
0 LCTOP (State),Other State Funds 5
1 5311 (Fed),LCTOP (State) 3
2 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Other State Funds 2
3 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Transit Development Act (State),Other State Funds 2
4 5311 (Fed),LCTOP (State),Transit Development Act (State) 2
5 5311 (Fed),LCTOP (State),Transit Development Act (State),Other State Funds,Other Federal Funds 2
6 LCTOP (State),SB1. State of Good Repair (State) 2
7 5311 (Fed),LCTOP (State),Other Federal Funds 1
8 5311 CMAQ (Fed),LCTOP (State),Other State Funds 1
9 LCTOP (State),Other Federal Funds 1
10 LCTOP (State),Other State Funds,Other Federal Funds 1
11 LCTOP (State),Transit Development Act (State),Other Federal Funds 1

How many applications did organizations submitted?¶

  • Most organizations (38) submitted one application. One organization submitted thirteen applications.

Methodology

  • Step 1 : Grouped by organization name and count the number of project upin numbers. Each upin number is unique to each application.
    • Example: Amador Transit applied 6 separate times.
  • Step 2 : Group again to see how many organizations applied for 1,2, etc. applications

How much funding did organizations by district request?¶

  • Hover over for number of applications and funding.
  • Agencies in District 6 (Fresno) submitted the highest number of separate applications.
  • Applicants in District 4 (Bay Area) asked for the most funding.

Which organizations applied? How much did they ask for?¶

  • District 4, Bay Area recorded the most organizations (23) that applied for grants. District 12, Orange County (1) had the least number of applicants.
  • Top 5 organizations that asked for the most funding:
    • Peninsula Corridor Join Powers Board asked for the most funding (182 million), followed by LA Metro (102 million).
    • 2/5 organizations are from District 4 and 2/5 are from District 6 Fresno.
  • Most organizations requested funds within the 50th percentile.

Top 5 organizations by total funding they requested
organization_name full_district_name total (millions)
0 Peninsula Corridor Joint Powers Board District 4: Bay Area / Oakland $182.8M
1 Los Angeles County Metropolitan Transportation Authority District 7: Los Angeles $102.48M
2 Tulare County Regional Transportation Agency District 6: Fresno / Bakersfield $27.67M
3 Kern Regional Transit District 6: Fresno / Bakersfield $23.6M
4 San Francisco Municipal Transportation Agency District 4: Bay Area / Oakland $20.34M
Number of organizations that applied for funds by district
count_of_organizations
full_district_name
District 12: Orange County 1
District 11: San Diego 3
District 9: Bishop 4
District 7: Los Angeles 6
District 1: Eureka 7
District 2: Redding 9
District 5: San Luis Obispo / Santa Barbara 10
District 8: San Bernardino / Riverside 12
District 10: Stockton 13
District 3: Marysville / Sacramento 15
District 6: Fresno / Bakersfield 18
District 4: Bay Area / Oakland 23

What mix of funds did organizations apply for?¶

Interpretation Examples

  • Amador Transit submitted 4 separate applications only for 5339. Submitted 2 separate applications asking for both LCTOP and 5311 funds.
  • City of Escalon had 1 application, only for 5311 fund.
    • They submitted 2 applications applying to a total of 5 programs: 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Transit Development Act (State),Other State Funds
  • Eastern Sierra Transit Authority submitted 13 different applications.
    • 4 applications were for 5311 only.
    • 1 application for 5311f and Transit Development Act
    • 1 for 5311f, Transit Devleopment Act, and Other State Funds
    • 4 for 5339 only
    • 2 for LCTOP only
    • 1 for LCTOP and SB1 State of Good Repair.
# of programs in a particular application # of times the org submitted an application in this particular combination
organization_name all_programs
Alameda-Contra Costa Transit District LCTOP (State) 1 2
Amador Transit 5311 (Fed),LCTOP (State) 2 2
5339 (Fed) 1 4
Butte County Association of Governments/ Butte Regional Transit 5311 (Fed),Transit Development Act (State) 2 2
5311(f) (Fed),Transit Development Act (State) 2 1
Calaveras Transit Agency 5311 (Fed),Transit Development Act (State) 2 2
LCTOP (State) 1 1
City of Arcata LCTOP (State) 1 1
City of Arvin 5311 (Fed),Transit Development Act (State) 2 2
5339 (Fed) 1 3
City of Auburn 5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State) 3 1
City of Banning LCTOP (State) 1 1
City of Beaumont LCTOP (State) 1 1
City of California City 5311 (Fed) 1 2
City of Chowchilla 5311 (Fed),Transit Development Act (State) 2 2
City of Clovis LCTOP (State) 1 1
City of Corcoran - Corcoran Area Transit 5311 (Fed) 1 2
LCTOP (State) 1 1
City of Davis LCTOP (State) 1 1
City of Dixon 5311 (Fed) 1 3
5311 (Fed),LCTOP (State) 2 1
5311 (Fed),Transit Development Act (State) 2 1
City of Escalon 5311 (Fed) 1 1
5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Transit Development Act (State),Other State Funds 5 2
City of Fairfield LCTOP (State),Other Federal Funds 2 1
City of Fresno LCTOP (State) 1 2
City of Guadalupe 5311 (Fed) 1 2
5339 (Fed) 1 4
LCTOP (State) 1 1
City of Manteca LCTOP (State) 1 1
City of McFarland 5311 (Fed),Other State Funds 2 2
LCTOP (State) 1 1
City of Needles 5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State) 3 2
City of Ojai 5311 (Fed),Other State Funds 2 2
5311 CMAQ (Fed) 1 1
City of Ridgecrest 5311 (Fed),Transit Development Act (State) 2 2
City of Rio Vista 5311 (Fed) 1 1
5311 (Fed),Transit Development Act (State) 2 2
City of Roseville 5311 CMAQ (Fed),LCTOP (State),Other State Funds 3 1
LCTOP (State) 1 1
City of San Luis Obispo Transit LCTOP (State) 1 1
City of Santa Rosa LCTOP (State) 1 1
City of Shafter 5311 (Fed),Transit Development Act (State) 2 2
LCTOP (State),SB1. State of Good Repair (State) 2 1
City of Solvang 5311 (Fed),Transit Development Act (State) 2 2
LCTOP (State) 1 1
City of Taft 5311 (Fed),Transit Development Act (State) 2 2
LCTOP (State),Other State Funds 2 1
City of Tehachapi 5311 (Fed),Transit Development Act (State) 2 2
City of Tracy LCTOP (State) 1 1
City of Union City Other State Funds 1 1
City of Visalia LCTOP (State) 1 1
City of Wasco 5311 (Fed),Transit Development Act (State) 2 2
LCTOP (State) 1 1
Colusa County Transit Agency LCTOP (State) 1 1
County Connection LCTOP (State) 1 2
County of Los Angeles - Department of Public Works 5311 (Fed) 1 2
County of Mariposa 5311 (Fed) 1 2
County of Nevada Public Works, Transit Services Division 5311 (Fed),Transit Development Act (State) 2 1
LCTOP (State) 1 1
County of Sacramento Department of Transportation 5311 (Fed) 1 2
County of Shasta Department of Public Works 5311 (Fed),Other State Funds 2 2
5311(f) (Fed) 1 1
County of Siskiyou LCTOP (State) 1 3
County of Tulare LCTOP (State) 1 1
Eastern Contra Costa Transit Authority LCTOP (State) 1 1
Eastern Sierra Transit Authority 5311 (Fed) 1 4
5311(f) (Fed),Transit Development Act (State) 2 1
5311(f) (Fed),Transit Development Act (State),Other State Funds 3 1
5339 (Fed) 1 4
LCTOP (State) 1 2
LCTOP (State),SB1. State of Good Repair (State) 2 1
El Dorado County Transit Authority 5311 (Fed) 1 2
5311(f) (Fed) 1 1
LCTOP (State) 1 1
LCTOP (State),Other State Funds 2 1
Fresno County Rural Transit Agency 5311 (Fed) 1 2
LCTOP (State) 1 1
Glenn County Transportation Commission 5311 (Fed) 1 1
Golden Empire Transit District LCTOP (State) 1 1
Golden Gate Highway & Transportation District LCTOP (State),Other State Funds,Other Federal Funds 3 1
Greyhound Lines, Inc. 5311(f) (Fed) 1 1
Humboldt Transit Authority 5311 (Fed) 1 2
5311 (Fed),Transit Development Act (State) 2 2
5311(f) (Fed),Transit Development Act (State) 2 2
5339 (Fed) 1 1
LCTOP (State) 1 1
Imperial County Transportation Commission 5311 (Fed),Transit Development Act (State),Other State Funds,Other Federal Funds 4 2
LCTOP (State) 1 1
Kern Regional Transit 5311 (Fed),Transit Development Act (State) 2 2
5339 (Fed),Other State Funds 2 3
LCTOP (State) 1 1
Kings County Area Public Transit Agency 5311 (Fed) 1 2
LCTOP (State) 1 3
Lake Transit Authority 5311 (Fed) 1 2
5311(f) (Fed) 1 2
5339 (Fed),Other State Funds 2 4
LCTOP (State) 1 1
Lassen Transit Service Agency 5311 (Fed),Other State Funds 2 2
5339 (Fed) 1 3
Livermore Amador Valley Transit Authority 5311 (Fed) 1 2
LCTOP (State) 1 1
Los Angeles County Metropolitan Transportation Authority LCTOP (State) 1 2
Madera County 5311 (Fed),Transit Development Act (State) 2 2
Madera County Transportation Commission LCTOP (State) 1 3
Marin County Transit District 5311 (Fed) 1 2
LCTOP (State) 1 1
Mendocino Transit Authority 5311 (Fed) 1 2
5311(f) (Fed) 1 1
Metropolitan Transportation Commission LCTOP (State) 1 2
Modoc Transportation Agency 5311 (Fed),Transit Development Act (State) 2 1
5311(f) (Fed),Transit Development Act (State) 2 3
Monterey-Salinas Transit 5311 (Fed) 1 2
5311(f) (Fed) 1 1
LCTOP (State) 1 4
Morongo Basin Transit Authority 5311 (Fed) 1 2
5311 CMAQ (Fed) 1 1
LCTOP (State) 1 2
Mountain Area Regional Transit Authority 5311 (Fed) 1 2
5311 CMAQ (Fed) 1 4
5311(f) (Fed) 1 2
LCTOP (State) 1 1
Napa Valley Transportation Authority 5311 (Fed),Transit Development Act (State) 2 1
5311(f) (Fed),Transit Development Act (State) 2 2
Other State Funds 1 1
North County Transit District 5311 (Fed) 1 2
LCTOP (State) 1 1
Omnitrans LCTOP (State) 1 2
Orange County Transportation Authority LCTOP (State) 1 2
Palo Verde Valley Transit Agency 5311 (Fed),Transit Development Act (State) 2 1
Peninsula Corridor Joint Powers Board LCTOP (State),Other State Funds 2 1
Plumas County Transportation Commission 5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State) 3 2
5311(f) (Fed),SB1. State of Good Repair (State),Other State Funds 3 1
5311(f) (Fed),SB1. State of Good Repair (State),Transit Development Act (State) 3 1
5339 (Fed) 1 3
LCTOP (State) 1 1
Redding Area Bus Aurthority LCTOP (State) 1 1
Redwood Coast Transit Authority 5311 (Fed) 1 2
5311(f) (Fed) 1 1
5339 (Fed) 1 3
LCTOP (State) 1 1
Riverside County Transportation Commission LCTOP (State) 1 1
Riverside Transit Agency 5311 (Fed) 1 2
LCTOP (State) 1 1
Sacramento Regional Transit District LCTOP (State) 1 6
San Benito County Local Transportation Authority 5311 (Fed),Transit Development Act (State) 2 2
LCTOP (State) 1 2
San Bernardino County Transportation Authority LCTOP (State) 1 2
San Diego Metropolitan Transit System 5311(f) (Fed) 1 1
LCTOP (State) 1 1
San Francisco Bay Area Rapid Transit LCTOP (State) 1 1
San Francisco Bay Area Water Emergency Transportation Authority LCTOP (State) 1 1
San Francisco Municipal Transportation Agency LCTOP (State) 1 2
San Joaquin Regional Rail Commission LCTOP (State) 1 1
San Joaquin Regional Transit District 5311 (Fed) 1 2
LCTOP (State) 1 1
San Luis Obispo Regional Transit Authority 5311 (Fed),Transit Development Act (State) 2 2
LCTOP (State),Transit Development Act (State),Other Federal Funds 3 1
San Mateo County Transit District 5311 (Fed) 1 2
Other State Funds,Other Federal Funds 2 1
Santa Barbara County Association of Governments LCTOP (State) 1 1
Santa Barbara Metropolitan Transit District Other State Funds 1 1
Santa Clara Valley Transportation Authority 5311 (Fed) 1 2
Other State Funds 1 1
Santa Cruz County Regional Transportation Commission LCTOP (State) 1 1
Santa Cruz Metropolitan Transit District 5311 (Fed) 1 2
5339 (Fed) 1 1
LCTOP (State) 1 1
Shasta Regional Transportation Agency LCTOP (State) 1 1
Sierra County Transportation Commission 5311 (Fed) 1 2
5339 (Fed) 1 2
Solano County Transit LCTOP (State),Other State Funds 2 1
Sonoma County Transit 5311 (Fed) 1 2
Sonoma-Marin Area Rail Transit District LCTOP (State) 1 1
Southern California Regional Rail Authority LCTOP (State) 1 1
Stanislaus Council of Governments LCTOP (State) 1 1
Stanislaus Regional Transit Authority 5311 (Fed),Transit Development Act (State) 2 2
Sunline Transit Agency 5311 (Fed) 1 2
5311(f) (Fed) 1 1
LCTOP (State) 1 1
Tehama County Transit Agency 5311 (Fed),LCTOP (State),Transit Development Act (State) 3 2
LCTOP (State) 1 1
Town of Truckee 5311 (Fed),LCTOP (State),Transit Development Act (State),Other State Funds,Other Federal Funds 5 2
Trinity County Department of Transportation 5311 (Fed) 1 4
5311(f) (Fed) 1 2
5339 (Fed) 1 1
Tulare County Regional Transportation Agency 5311 (Fed),Transit Development Act (State),Other Federal Funds 3 2
5339 (Fed),Other State Funds 2 4
Tuolumne County Transit Agency 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Other State Funds 4 2
LCTOP (State) 1 1
Ventura County Transportation Commission 5311 (Fed),Other State Funds 2 2
LCTOP (State) 1 2
Victor Valley Transit Authority 5311 (Fed),LCTOP (State),Other Federal Funds 3 1
5311 (Fed),Other Federal Funds 2 1
Western Contra Costa Transit Authority LCTOP (State) 1 1
Yolo County Transportation District 5311 (Fed) 1 2
LCTOP (State),Other State Funds 2 1
Yuba-Sutter Transit Authority 5311 (Fed) 1 2
5311 (Fed),Other State Funds 2 4
LCTOP (State) 1 1
Yurok Tribe Transit 5311(f) (Fed) 1 1